package com.sofly.dao.group3;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.sofly.entity.PurchaseList;
/**
 * 
* <p>Title:IPurchaseListDao </p>
* <p>Description: </p>
* <p>Company: </p> 
* @author ChengShiMin
* @date 下午6:55:12
 */
public interface IPurchaseListDao {

	public List<PurchaseList> selectPurchaseList(@Param("offset")int offset,@Param("limit")int limit);//分页查询
	
	public PurchaseList selectPurchase(String purchaseId);//订单查询
	
	public int selectCount();//订单总数
	
	public int selectCount1(String saveDate);
	
	public int selectCount2(@Param("minprice")double minprice,@Param("maxprice")double maxprice);
	
	public int selectCount3(@Param("starttime")String starttime,@Param("endtime")String endtime);
	
	public int insertPurchaseList(PurchaseList purchaseList);//添加订单
	
	public int updatePurchaseList(PurchaseList purchaseList);//修改订单
	
	public List<PurchaseList> selectPurchaseListByDate(@Param("saveDate")String saveDate,@Param("offset")int offset,@Param("limit")int limit);
	
	public List<PurchaseList> selectPurchaseListByPrice(@Param("minprice")double minprice,@Param("maxprice")double maxprice,@Param("offset")int offset,@Param("limit")int limit);
	
	public List<PurchaseList> selectPurchaseListByDate1(@Param("starttime")String starttime,@Param("endtime")String endtime,@Param("offset")int offset,@Param("limit")int limit);
	
}
